﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Grain.Crm.ExcelExtractor.Input;

namespace Grain.Crm.ExcelExtractor.InputDescription.Sheets
{
    public class EducationSheetDescription : SheetDescription
    {
        public int NextRecordRowDiff = 10;
        public int RecordsCount = 4;

        public void Build()
        {
            this.SheetName = "Education";

            this.Descriptions.Add(new ValueDescription() { CrmDisplayName = "School", CrmEntity = CrmEntityName.Education, Column = 3, Row = 5 });

            this.Descriptions.Add(new ValueDescription() { CrmDisplayName = "Education level", CrmEntity = CrmEntityName.Education, Column = 3, Row = 6 });

            this.Descriptions.Add(new ValueDescription() { CrmDisplayName = "Faculty", CrmEntity = CrmEntityName.Education, Column = 3, Row = 7 });

            this.Descriptions.Add(new ValueDescription() { CrmDisplayName = "Specialization", CrmEntity = CrmEntityName.Education, Column = 3, Row = 8 });

            //this.Descriptions.Add(new ValueDescription() { CrmDisplayName = "Country", CrmEntity = CrmEntityName.Education, Column = 3, Row = 9 });

            //this.Descriptions.Add(new ValueDescription() { CrmDisplayName = "City", CrmEntity = CrmEntityName.Education, Column = 3, Row = 10 });

            this.Descriptions.Add(new ValueDescription() { CrmDisplayName = "Start Date", ParseDateAs = DateFormat.DaysSince1900, CrmEntity = CrmEntityName.Education, Column = 3, Row = 11 });

            this.Descriptions.Add(new ValueDescription() { CrmDisplayName = "End Date", ParseDateAs = DateFormat.DaysSince1900, CrmEntity = CrmEntityName.Education, Column = 3, Row = 12 });


        }
    }
}
